Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# What's New in Oracle Database Reference?

This section describes new features of Oracle Database 10g release 2 (10.2) and provides pointers to additional information. New features information from release 1 (10.1) is also retained to help those users upgrading to the current release. For information on features that were new in earlier releases of the Oracle Database, refer to the documentation for the earlier release.

The following sections describe the new features in Oracle Database Reference:

- Oracle Database 10g Release 2 (10.2) New Features

- Oracle Database 10g Release 1 (10.1) New Features

## Oracle Database 10g Release 2 (10.2) New Features

The following initialization parameters are new to release 10.2:

`AUDIT_SYSLOG_LEVEL`
`COMMIT_WRITE`
`OPTIMIZER_SECURE_VIEW_MERGING`
`PLSQL_CCFLAGS`
`RECYCLEBIN`

See Also: Part I, "Initialization Parameters" for more information about these initialization parameters

The following static data dictionary views are new to release 10.2:

ALL_ Views | DBA_ Views | USER_ Views
--- | --- | ---
`ALL_DEQUEUE_QUEUES` |  |
| `DBA_APPLY_OBJECT_DEPENDENCIES` |
| `DBA_APPLY_SPILL_TXN` |
| `DBA_APPLY_VALUE_DEPENDENCIES` |
| `DBA_AUTO_SEGADV_CTL` |
| `DBA_AUTO_SEGADV_SUMMARY` |
| `DBA_CHANGE_NOTIFICATION_REGS` | `USER_CHANGE_NOTIFICATION_REGS`
| `DBA_CONNECT_ROLE_GRANTEES` |
| `DBA_CPU_USAGE_STATISTICS` |
`ALL_ENCRYPTED_COLUMNS` | `DBA_ENCRYPTED_COLUMNS` | `USER_ENCRYPTED_COLUMNS`
`ALL_FILE_GROUP_EXPORT_INFO` | `DBA_FILE_GROUP_EXPORT_INFO` | `USER_FILE_GROUP_EXPORT_INFO`
`ALL_FILE_GROUP_FILES` | `DBA_FILE_GROUP_FILES` | `USER_FILE_GROUP_FILES`
`ALL_FILE_GROUP_TABLES` | `DBA_FILE_GROUP_TABLES` | `USER_FILE_GROUP_TABLES`
`ALL_FILE_GROUP_TABLESPACES` | `DBA_FILE_GROUP_TABLESPACES` | `USER_FILE_GROUP_TABLESPACES`
`ALL_FILE_GROUP_VERSIONS` | `DBA_FILE_GROUP_VERSIONS` | `USER_FILE_GROUP_VERSIONS`
`ALL_FILE_GROUPS` | `DBA_FILE_GROUPS` | `USER_FILE_GROUPS`
| `DBA_HIST_BUFFERED_QUEUES` |
| `DBA_HIST_BUFFERED_SUBSCRIBERS` |
| `DBA_HIST_COMP_IOSTAT` |
| `DBA_HIST_PROCESS_MEM_SUMMARY` |
| `DBA_HIST_RULE_SET` |
| `DBA_HIST_SESS_TIME_STATS` |
| `DBA_HIST_SGA_TARGET_ADVICE` |
| `DBA_HIST_SQL_BIND_METADATA` |
| `DBA_HIST_STREAMS_APPLY_SUM` |
| `DBA_HIST_STREAMS_CAPTURE` |
| `DBA_HIST_STREAMS_POOL_ADVICE` |
`ALL_QUEUE_SUBSCRIBERS` | `DBA_QUEUE_SUBSCRIBERS` | `USER_QUEUE_SUBSCRIBERS`
| `DBA_RECOVERABLE_SCRIPT` |
| `DBA_RECOVERABLE_SCRIPT_BLOCKS` |
| `DBA_RECOVERABLE_SCRIPT_ERRORS` |
| `DBA_RECOVERABLE_SCRIPT_PARAMS` |
| `DBA_REGISTRY_HISTORY` |
| `DBA_REGISTRY_LOG` |
| `DBA_RESOURCE_INCARNATIONS` |
`ALL_SCHEDULER_CHAIN_RULES` | `DBA_SCHEDULER_CHAIN_RULES` | `USER_SCHEDULER_CHAIN_RULES`
`ALL_SCHEDULER_CHAIN_STEPS` | `DBA_SCHEDULER_CHAIN_STEPS` | `USER_SCHEDULER_CHAIN_STEPS`
`ALL_SCHEDULER_CHAINS` | `DBA_SCHEDULER_CHAINS` | `USER_SCHEDULER_CHAINS`
`ALL_SCHEDULER_RUNNING_CHAINS` | `DBA_SCHEDULER_RUNNING_CHAINS` | `USER_SCHEDULER_RUNNING_CHAINS`
| `DBA_SEGMENTS_OLD` |
`ALL_SQLSET` |  |
`ALL_SQLSET_BINDS` |  |
`ALL_SQLSET_PLANS` | `DBA_SQLSET_PLANS` | `USER_SQLSET_PLANS`
`ALL_SQLSET_REFERENCES` |  |
`ALL_SQLSET_STATEMENTS` |  |
| `DBA_STREAMS_ADD_COLUMN` |
| `DBA_STREAMS_DELETE_COLUMN` |
| `DBA_STREAMS_RENAME_COLUMN` |
| `DBA_STREAMS_RENAME_SCHEMA` |
| `DBA_STREAMS_RENAME_TABLE` |
| `DBA_STREAMS_TRANSFORMATIONS` |
| `DBA_TSM_DESTINATION` |
| `DBA_TSM_SOURCE` |
| `DBA_WORKSPACE_SESSIONS` |
`ALL_WORKSPACES` | `DBA_WORKSPACES` | `USER_WORKSPACES`

See Also: Part II, "Static Data Dictionary Views" for more information about these static data dictionary views

The following dynamic performance views are new to release 10.2:

GV$ Views | V$ Views
--- | ---
`GV$ASM_DISK_STAT` | `V$ASM_DISK_STAT`
`GV$ASM_DISKGROUP_STAT` | `V$ASM_DISKGROUP_STAT`
| `V$BACKUP_ARCHIVELOG_DETAILS`
| `V$BACKUP_ARCHIVELOG_SUMMARY`
| `V$BACKUP_CONTROLFILE_DETAILS`
| `V$BACKUP_CONTROLFILE_SUMMARY`
| `V$BACKUP_COPY_DETAILS`
| `V$BACKUP_COPY_SUMMARY`
| `V$BACKUP_DATAFILE_DETAILS`
| `V$BACKUP_DATAFILE_SUMMARY`
| `V$BACKUP_PIECE_DETAILS`
| `V$BACKUP_SET_DETAILS`
| `V$BACKUP_SET_SUMMARY`
| `V$BACKUP_SPFILE_DETAILS`
| `V$BACKUP_SPFILE_SUMMARY`
`GV$BLOCKING_QUIESCE` | `V$BLOCKING_QUIESCE`
`GV$CLUSTER_INTERCONNECTS` | `V$CLUSTER_INTERCONNECTS`
`GV$CONFIGURED_INTERCONNECTS` | `V$CONFIGURED_INTERCONNECTS`
| `V$DATAGUARD_STATS`
| `V$DB_TRANSPORTABLE_PLATFORM`
| `V$FLASH_RECOVERY_AREA_USAGE`
`GV$LOGMNR_DICTIONARY_LOAD` | `V$LOGMNR_DICTIONARY_LOAD`
`GV$LOGSTDBY_PROCESS` | `V$LOGSTDBY_PROCESS`
`GV$LOGSTDBY_PROGRESS` | `V$LOGSTDBY_PROGRESS`
`GV$LOGSTDBY_STATE` | `V$LOGSTDBY_STATE`
`GV$LOGSTDBY_TRANSACTION` | `V$LOGSTDBY_TRANSACTION`
`GV$MUTEX_SLEEP` | `V$MUTEX_SLEEP`
`GV$MUTEX_SLEEP_HISTORY` | `V$MUTEX_SLEEP_HISTORY`
`GV$PROCESS_MEMORY` | `V$PROCESS_MEMORY`
`GV$PARAMETER_VALID_VALUES` | `V$PARAMETER_VALID_VALUES`
| `V$PROXY_ARCHIVELOG_DETAILS`
| `V$PROXY_ARCHIVELOG_SUMMARY`
| `V$PROXY_COPY_DETAILS`
| `V$PROXY_COPY_SUMMARY`
`GV$RESERVED_WORDS` | `V$RESERVED_WORDS`
`GV$RESTORE_POINT` | `V$RESTORE_POINT`
`GV$RFS_THREAD` | `V$RFS_THREAD`
| `V$RMAN_BACKUP_JOB_DETAILS`
| `V$RMAN_BACKUP_SUBJOB_DETAILS`
| `V$RMAN_BACKUP_TYPE`
| `V$RMAN_ENCRYPTION_ALGORITHMS`
`GV$RSRC_CONS_GROUP_HISTORY` | `V$RSRC_CONS_GROUP_HISTORY`
`GV$RSRC_PLAN_HISTORY` | `V$RSRC_PLAN_HISTORY`
`GV$RSRC_SESSION_INFO` | `V$RSRC_SESSION_INFO`
`GV$SCHEDULER_RUNNING_JOBS` | `V$SCHEDULER_RUNNING_JOBS`
`GV$SGA_TARGET_ADVICE` | `V$SGA_TARGET_ADVICE`
`GV$SQL_JOIN_FILTER` | `V$SQL_JOIN_FILTER`
`GV$SQLAREA_PLAN_HASH` | `V$SQLAREA_PLAN_HASH`
`GV$SQLSTATS` | `V$SQLSTATS`
`GV$STREAMS_POOL_ADVICE` | `V$STREAMS_POOL_ADVICE`
`GV$STREAMS_TRANSACTION` | `V$STREAMS_TRANSACTION`
`GV$TSM_SESSIONS` | `V$TSM_SESSIONS`
| `V$UNUSABLE_BACKUPFILE_DETAILS`
`GV$WALLET` | `V$WALLET`
`GV$XML_AUDIT_TRAIL` | `V$XML_AUDIT_TRAIL`

See Also: Part III, "Dynamic Performance Views" for more information about these dynamic performance views

The following static data dictionary views have new columns in release 10.2:

Static Data Dictionary Views | New Columns
--- | ---
`ALL_DEF_AUDIT_OPTS` | `REA`
`ALL_PROPAGATION` | `ERROR_DATE` `ERROR_MESSAGE` `ERROR_STATUS`
`ALL_SCHEDULER_JOBS` | `SCHEDULE_TYPE`
`ALL_SCHEDULER_PROGRAMS` | `DETACHED`
`ALL_SCHEDULER_RUNNING_CHAINS` | `JOB_SUBNAME` `STEP_JOB_LOG_ID`
`ALL_SCHEDULER_RUNNING_JOBS` | `SLAVE_OS_PROCESS_ID`
`ALL_SCHEDULER_SCHEDULES` | `SCHEDULE_TYPE`
`ALL_SCHEDULER_WINDOW_GROUPS` | `NEXT_START_DATE`
`ALL_SCHEDULER_WINDOWS` | `MANUAL_DURATION` `MANUAL_OPEN_TIME` `SCHEDULE_TYPE`
`ALL_SERVICES` | `CLB_GOAL`
`ALL_STREAMS_TRANSFORM_FUNCTION` | `CUSTOM_TYPE`
`DBA_ADVISOR_OBJECTS` | `OTHER`
`DBA_AUDIT_EXISTS` | `ECONTEXT_ID`
`DBA_AUDIT_OBJECT` | `ECONTEXT_ID`
`DBA_AUDIT_STATEMENT` | `ECONTEXT_ID`
`DBA_AUDIT_TRAIL` | `ECONTEXT_ID`
`DBA_COMMON_AUDIT_TRAIL` | `OS_PRIVILEGE` `ECONTEXT_ID`
`DBA_FGA_AUDIT_TRAIL` | `ECONTEXT_ID`
`DBA_HIST_SQLSTAT` | `FORCE_MATCHING_SIGNATURE` `BIND_DATA`
`DBA_HIST_ACTIVE_SESS_HISTORY` | `P1TEXT` `P2TEXT` `P3TEXT` `PX_SERVERS_EXECS_DELTA` `PX_SERVERS_EXECS_TOTAL` `PARSING_SCHEMA_NAME` `BLOCKING_SESSION_SERIAL``#` `FORCE_MATCHING_SIGNATURE`
`DBA_PROPAGATION` | `ERROR_DATE` `ERROR_MESSAGE` `ERROR_STATUS`
`DBA_REGISTERED_ARCHIVED_LOG` | `RESETLOGS_CHANGE#` `RESET_TIMESTAMP`
`DBA_SCHEDULER_JOBS` | `SCHEDULE_TYPE`
`DBA_SCHEDULER_RUNNING_CHAINS` | `JOB_SUBNAME` `STEP_JOB_LOG_ID`
`DBA_SCHEDULER_RUNNING_JOBS` | `SLAVE_OS_PROCESS_ID`
`DBA_SCHEDULER_SCHEDULES` | `SCHEDULE_TYPE`
`DBA_SCHEDULER_WINDOW_GROUPS` | `NEXT_START_DATE`
`DBA_SCHEDULER_WINDOWS` | `MANUAL_DURATION` `MANUAL_OPEN_TIME` `SCHEDULE_TYPE`
`DBA_SERVICES` | `CLB_GOAL`
`DBA_SQLTUNE_STATISTICS` | `DIRECT_WRITES`
`DBA_STREAMS_TRANSFORM_FUNCTION` | `CUSTOM_TYPE`
`DBA_TS_QUOTAS` | `DROPPED`
`USER_AUDIT_OBJECT` | `ECONTEXT_ID`
`USER_AUDIT_STATEMENT` | `ECONTEXT_ID`
`USER_AUDIT_TRAIL` | `ECONTEXT_ID`
`USER_SCHEDULER_JOBS` | `SCHEDULE_TYPE`
`USER_SCHEDULER_RUNNING_CHAINS` | `JOB_SUBNAME` `STEP_JOB_LOG_ID`
`USER_SCHEDULER_RUNNING_JOBS` | `SLAVE_OS_PROCESS_ID`
`USER_SCHEDULER_SCHEDULES` | `SCHEDULE_TYPE`
`USER_SQLTUNE_STATISTICS` | `DIRECT_WRITES`
`USER_TS_QUOTAS` | `DROPPED`

See Also: Part II, "Static Data Dictionary Views" for more information about the new columns in these static data dictionary views

The following dynamic performance views have new columns in release 10.2:

Dynamic Performance View | New Columns
--- | ---
`V$ACTIVE_SESSION_HISTORY` | `P1TEXT` `P2TEXT` `P3TEXT` `BLOCKING_SESSION_SERIAL#` `FORCE_MATCHING_SIGNATURE`
`V$ARCHIVE_DEST` | `MAX_CONNECTIONS`
`V$ARCHIVE_DEST_STATUS` | `PROTECTION_REASON`
| `SYNCHRONIZED`
`V$ARCHIVED_LOG` | `END_OF_REDO_TYPE`
`V$ASM_DISK` | `PRODUCT`
`V$ASM_DISKGROUP` | `COMPATIBILITY`
| `DATABASE_COMPATIBILITY`
`V$ASM_DISK_STAT` | `PRODUCT`
`V$BACKUP_DATAFILE` | `USED_OPTIMIZATION`
`V$BUFFERED_PUBLISHERS` | `MEMORY_USAGE` `OVERSPILLED_MSGS` `PUBLISHER_STATE` `UNBROWSED_MSGS`
`V$DATAFILE` | `FIRST_NONLOGGED_SCN` `FIRST_NONLOGGED_TIME`
`V$DATAFILE_HEADER` | `LAST_DEALLOC_SCN` `SPACE_HEADER`
`V$DB_OBJECT_CACHE` | `INVALIDATIONS`
`V$LATCHHOLDER` | `GETS`
`V$LICENSE` | `CPU_COUNT_CURRENT` `CPU_CORE_COUNT_CURRENT` `CPU_SOCKET_COUNT_CURRENT` `CPU_COUNT_HIGHWATER` `CPU_CORE_COUNT_HIGHWATER` `CPU_SOCKET_COUNT_HIGHWATER`
`V$PROPAGATION_RECEIVER` | `DST_QUEUE_NAME` `TOTAL_MSGS` `DST_QUEUE_SCHEMA` `SRC_QUEUE_SCHEMA`
`V$PROPAGATION_SENDER` | `DST_QUEUE_NAME` `DST_QUEUE_SCHEMA` `STARTUP_TIME`
`V$RECOVERY_PROGRESS` | `START_TIME` `TIMESTAMP` `UNITS`
`V$RMAN_OUTPUT` | `SESSION_KEY`
`V$SERVICEMETRIC` | `CALLSPERSEC` `DBTIMEPERCALL` `DBTIMEPERSEC`
`V$SERVICEMETRIC_HISTORY` | `CALLSPERSEC` `DBTIMEPERCALL` `DBTIMEPERSEC`
`V$SESSION` | `BLOCKING_INSTANCE`
`V$SESSION_LONGOPS` | `TIMESTAMP`
`V$SQL` | `BIND_DATA` `FORCE_MATCHING_SIGNATURE` `PX_SERVERS_EXECUTIONS` `SERVICE` `SERVICE_HASH`
`V$SQL_SHARED_CURSOR` | `MV_STALEOBJ_MISMATCH` `OPTIMIZER_MODE_MISMATCH` `PX_MISMATCH` `FLASHBACK_TABLE_MISMATCH` `BIND_PEEKED_PQ_MISMATCH` `CURSOR_PARTS_MISMATCH` `PQ_SLAVE_MISMATCH` `LITREP_COMP_MISMATCH` `MULTI_PX_MISMATCH` `MV_REWRITE_MISMATCH` `ROLL_INVALID_MISMATCH` `ROW_SHIP_MISMATCH` `STD_OBJECT_MISMATCH` `TOP_LEVEL_DDL_MISMATCH`
`V$SQLAREA` | `BIND_DATA` `FORCE_MATCHING_SIGNATURE` `PX_SERVERS_EXECUTIONS`
`V$STREAMS_APPLY_COORDINATOR` | `ELAPSED_IDLE_TIME`
`V$STREAMS_APPLY_READER` | `ELAPSED_SPILL_TIME` `TOTAL_MESSAGES_SPILLED`
`V$STREAMS_CAPTURE` | `STATE_CHANGED_TIME`
`V$TABLESPACE` | `ENCRYPT_IN_BACKUP`
`V$THREAD` | `LAST_REDO_CHANGE#` `LAST_REDO_TIME` `LAST_REDO_BLOCK` `LAST_REDO_SEQUENCE#`
`V$THRESHOLD_TYPES` | `METRIC_VALUE_TYPE`

See Also: Part III, "Dynamic Performance Views" for more information about the new columns in these dynamic performance views

## Oracle Database 10g Release 1 (10.1) New Features

The following initialization parameters are new to release 10.1:

`ASM_DISKGROUPS`
`ASM_DISKSTRING`
`ASM_POWER_LIMIT`
`CREATE_STORED_OUTLINES`
`DB_FLASHBACK_RETENTION_TARGET`
`DB_RECOVERY_FILE_DEST`
`DB_RECOVERY_FILE_DEST_SIZE`
`DB_UNIQUE_NAME`
`DDL_WAIT_FOR_LOCKS`
`FILEIO_NETWORK_ADAPTERS`
`GCS_SERVER_PROCESSES`
`INSTANCE_TYPE`
`LDAP_DIRECTORY_ACCESS`
`LOG_ARCHIVE_CONFIG`
`LOG_ARCHIVE_LOCAL_FIRST`
`PLSQL_CODE_TYPE`
`PLSQL_DEBUG`
`PLSQL_OPTIMIZE_LEVEL`
`PLSQL_WARNINGS`
`RESUMABLE_TIMEOUT`
`SGA_TARGET`
`SKIP_UNUSABLE_INDEXES`
`SMTP_OUT_SERVER`
`SQLTUNE_CATEGORY`
`STREAMS_POOL_SIZE`

See Also: Part I, "Initialization Parameters" for more information about these initialization parameters

The following static data dictionary views are new to release 10.1:

ALL_ Views | DBA_ Views | USER_ Views
--- | --- | ---
| `DBA_ADVISOR_ACTIONS` | `USER_ADVISOR_ACTIONS`
| `DBA_ADVISOR_COMMANDS` |
| `DBA_ADVISOR_DEFINITIONS` |
| `DBA_ADVISOR_FINDINGS` | `USER_ADVISOR_FINDINGS`
| `DBA_ADVISOR_JOURNAL` | `USER_ADVISOR_JOURNAL`
| `DBA_ADVISOR_LOG` | `USER_ADVISOR_LOG`
| `DBA_ADVISOR_OBJECT_TYPES` |
| `DBA_ADVISOR_OBJECTS` | `USER_ADVISOR_OBJECTS`
| `DBA_ADVISOR_PARAMETERS` | `USER_ADVISOR_PARAMETERS`
| `DBA_ADVISOR_RATIONALE` | `USER_ADVISOR_RATIONALE`
| `DBA_ADVISOR_RECOMMENDATIONS` | `USER_ADVISOR_RECOMMENDATIONS`
| `DBA_ADVISOR_SQLA_REC_SUM` | `USER_ADVISOR_SQLA_REC_SUM`
| `DBA_ADVISOR_SQLA_WK_MAP` | `USER_ADVISOR_SQLA_WK_MAP`
| `DBA_ADVISOR_SQLA_WK_STMTS` | `USER_ADVISOR_SQLA_WK_STMTS`
| `DBA_ADVISOR_SQLW_JOURNAL` | `USER_ADVISOR_SQLW_JOURNAL`
| `DBA_ADVISOR_SQLW_PARAMETERS` | `USER_ADVISOR_SQLW_PARAMETERS`
| `DBA_ADVISOR_SQLW_STMTS` | `USER_ADVISOR_SQLW_STMTS`
| `DBA_ADVISOR_SQLW_SUM` | `USER_ADVISOR_SQLW_SUM`
| `DBA_ADVISOR_SQLW_TABLES` | `USER_ADVISOR_SQLW_TABLES`
| `DBA_ADVISOR_SQLW_TEMPLATES` | `USER_ADVISOR_SQLW_TEMPLATES`
| `DBA_ADVISOR_TASKS` | `USER_ADVISOR_TASKS`
| `DBA_ADVISOR_TEMPLATES` | `USER_ADVISOR_TEMPLATES`
| `DBA_ADVISOR_USAGE` |
| `DBA_ALERT_HISTORY` |
`ALL_APPLY_ENQUEUE` | `DBA_APPLY_ENQUEUE` |
`ALL_APPLY_EXECUTE` | `DBA_APPLY_EXECUTE` |
| `DBA_APPLY_INSTANTIATED_GLOBAL` |
| `DBA_APPLY_INSTANTIATED_SCHEMAS` |
`ALL_APPLY_TABLE_COLUMNS` | `DBA_APPLY_TABLE_COLUMNS` |
`ALL_AUDIT_POLICY_COLUMNS` | `DBA_AUDIT_POLICY_COLUMNS` | `USER_AUDIT_POLICY_COLUMNS`
`ALL_AW_PS` |  |
`ALL_AWS` |  |
`ALL_CAPTURE_EXTRA_ATTRIBUTES` | `DBA_CAPTURE_EXTRA_ATTRIBUTES` |
| `DBA_COMMON_AUDIT_TRAIL` |
| `DBA_DATAPUMP_JOBS` | `USER_DATAPUMP_JOBS`
| `DBA_DATAPUMP_SESSIONS` |
| `DBA_ENABLED_AGGREGATIONS` |
| `DBA_ENABLED_TRACES` |
| `DBA_FEATURE_USAGE_STATISTICS` |
| `DBA_HIGH_WATER_MARK_STATISTICS` |
| `DBA_HIST_ACTIVE_SESS_HISTORY` |
| `DBA_HIST_BASELINE` |
| `DBA_HIST_BG_EVENT_SUMMARY` |
| `DBA_HIST_BUFFER_POOL_STAT` |
| `DBA_HIST_CR_BLOCK_SERVER` |
| `DBA_HIST_CURRENT_BLOCK_SERVER` |
| `DBA_HIST_DATABASE_INSTANCE` |
| `DBA_HIST_DATAFILE` |
| `DBA_HIST_DB_CACHE_ADVICE` |
| `DBA_HIST_DLM_MISC` |
| `DBA_HIST_ENQUEUE_STAT` |
| `DBA_HIST_EVENT_NAME` |
| `DBA_HIST_FILEMETRIC_HISTORY` |
| `DBA_HIST_FILESTATXS` |
| `DBA_HIST_INST_CACHE_TRANSFER` |
| `DBA_HIST_INSTANCE_RECOVERY` |
| `DBA_HIST_JAVA_POOL_ADVICE` |
| `DBA_HIST_LATCH` |
| `DBA_HIST_LATCH_CHILDREN` |
| `DBA_HIST_LATCH_MISSES_SUMMARY` |
| `DBA_HIST_LATCH_NAME` |
| `DBA_HIST_LATCH_PARENT` |
| `DBA_HIST_LIBRARYCACHE` |
| `DBA_HIST_LOG` |
| `DBA_HIST_METRIC_NAME` |
| `DBA_HIST_MTTR_TARGET_ADVICE` |
| `DBA_HIST_OPTIMIZER_ENV` |
| `DBA_HIST_OSSTAT` |
| `DBA_HIST_OSSTAT_NAME` |
| `DBA_HIST_PARAMETER` |
| `DBA_HIST_PARAMETER_NAME` |
| `DBA_HIST_PGA_TARGET_ADVICE` |
| `DBA_HIST_PGASTAT` |
| `DBA_HIST_RESOURCE_LIMIT` |
| `DBA_HIST_ROWCACHE_SUMMARY` |
| `DBA_HIST_SEG_STAT` |
| `DBA_HIST_SEG_STAT_OBJ` |
| `DBA_HIST_SERVICE_NAME` |
| `DBA_HIST_SERVICE_STAT` |
| `DBA_HIST_SERVICE_WAIT_CLASS` |
| `DBA_HIST_SESSMETRIC_HISTORY` |
| `DBA_HIST_SGA` |
| `DBA_HIST_SGASTAT` |
| `DBA_HIST_SHARED_POOL_ADVICE` |
| `DBA_HIST_SNAP_ERROR` |
| `DBA_HIST_SNAPSHOT` |
| `DBA_HIST_SQL_PLAN` |
| `DBA_HIST_SQL_SUMMARY` |
| `DBA_HIST_SQL_WORKAREA_HSTGRM` |
| `DBA_HIST_SQLBIND` |
| `DBA_HIST_SQLSTAT` |
| `DBA_HIST_SQLTEXT` |
| `DBA_HIST_STAT_NAME` |
| `DBA_HIST_SYS_TIME_MODEL` |
| `DBA_HIST_SYSMETRIC_HISTORY` |
| `DBA_HIST_SYSMETRIC_SUMMARY` |
| `DBA_HIST_SYSSTAT` |
| `DBA_HIST_SYSTEM_EVENT` |
| `DBA_HIST_TABLESPACE_STAT` |
| `DBA_HIST_TBSPC_SPACE_USAGE` |
| `DBA_HIST_TEMPFILE` |
| `DBA_HIST_TEMPSTATXS` |
| `DBA_HIST_THREAD` |
| `DBA_HIST_UNDOSTAT` |
| `DBA_HIST_WAITCLASSMET_HISTORY` |
| `DBA_HIST_WAITSTAT` |
| `DBA_HIST_WR_CONTROL` |
`ALL_IND_STATISTICS` | `DBA_IND_STATISTICS` | `USER_IND_STATISTICS`
`ALL_INDEXTYPE_ARRAYTYPES` | `DBA_INDEXTYPE_ARRAYTYPES` | `USER_INDEXTYPE_ARRAYTYPES`
| `DBA_LOGMNR_LOG` |
| `DBA_LOGMNR_PURGED_LOG` |
| `DBA_LOGMNR_SESSION` |
`ALL_MVIEW_COMMENTS` | `DBA_MVIEW_COMMENTS` | `USER_MVIEW_COMMENTS`
`ALL_NESTED_TABLE_COLS` | `DBA_NESTED_TABLE_COLS` | `USER_NESTED_TABLE_COLS`
| `DBA_OUTSTANDING_ALERTS` |
`ALL_PLSQL_OBJECT_SETTINGS` | `DBA_PLSQL_OBJECT_SETTINGS` | `USER_PLSQL_OBJECT_SETTINGS`
| `DBA_RECYCLEBIN` | `USER_RECYCLEBIN`
| `DBA_REDEFINITION_ERRORS` |
| `DBA_REDEFINITION_OBJECTS` |
| `DBA_REGISTERED_ARCHIVED_LOG` |
`ALL_REWRITE_EQUIVALENCES` | `DBA_REWRITE_EQUIVALENCES` | `USER_REWRITE_EQUIVALENCES`
| `DBA_RSRC_GROUP_MAPPINGS` |
| `DBA_RSRC_MAPPING_PRIORITY` |
`ALL_SCHEDULER_JOB_ARGS` | `DBA_SCHEDULER_JOB_ARGS` | `USER_SCHEDULER_JOB_ARGS`
`ALL_SCHEDULER_JOB_CLASSES` | `DBA_SCHEDULER_JOB_CLASSES` |
`ALL_SCHEDULER_JOB_LOG` | `DBA_SCHEDULER_JOB_LOG` | `USER_SCHEDULER_JOB_LOG`
`ALL_SCHEDULER_JOB_RUN_DETAILS` | `DBA_SCHEDULER_JOB_RUN_DETAILS` | `USER_SCHEDULER_JOB_RUN_DETAILS`
`ALL_SCHEDULER_JOBS` | `DBA_SCHEDULER_JOBS` | `USER_SCHEDULER_JOBS`
`ALL_SCHEDULER_PROGRAM_ARGS` | `DBA_SCHEDULER_PROGRAM_ARGS` | `USER_SCHEDULER_PROGRAM_ARGS`
`ALL_SCHEDULER_PROGRAMS` | `DBA_SCHEDULER_PROGRAMS` | `USER_SCHEDULER_PROGRAMS`
`ALL_SCHEDULER_RUNNING_JOBS` | `DBA_SCHEDULER_RUNNING_JOBS` | `USER_SCHEDULER_RUNNING_JOBS`
`ALL_SCHEDULER_SCHEDULES` | `DBA_SCHEDULER_SCHEDULES` | `USER_SCHEDULER_SCHEDULES`
`ALL_SCHEDULER_WINDOW_DETAILS` | `DBA_SCHEDULER_WINDOW_DETAILS` |
`ALL_SCHEDULER_WINDOW_GROUPS` | `DBA_SCHEDULER_WINDOW_GROUPS` |
`ALL_SCHEDULER_WINDOW_LOG` | `DBA_SCHEDULER_WINDOW_LOG` |
`ALL_SCHEDULER_WINDOWS` | `DBA_SCHEDULER_WINDOWS` |
`ALL_SCHEDULER_WINGROUP_MEMBERS` | `DBA_SCHEDULER_WINGROUP_MEMBERS` |
`ALL_SEC_RELEVANT_COLS` | `DBA_SEC_RELEVANT_COLS` | `USER_SEC_RELEVANT_COLS`
| `DBA_SERVER_REGISTRY` |
`ALL_SERVICES` | `DBA_SERVICES` |
| `DBA_SQL_PROFILES` |
| `DBA_SQLSET` | `USER_SQLSET`
| `DBA_SQLSET_BINDS` | `USER_SQLSET_BINDS`
| `DBA_SQLSET_REFERENCES` | `USER_SQLSET_REFERENCES`
| `DBA_SQLSET_STATEMENTS` | `USER_SQLSET_STATEMENTS`
| `DBA_SQLTUNE_BINDS` | `USER_SQLTUNE_BINDS`
| `DBA_SQLTUNE_PLANS` | `USER_SQLTUNE_PLANS`
| `DBA_SQLTUNE_RATIONALE_PLAN` | `USER_SQLTUNE_RATIONALE_PLAN`
| `DBA_SQLTUNE_STATISTICS` | `USER_SQLTUNE_STATISTICS`
| `DBA_STREAMS_ADMINISTRATOR` |
`ALL_STREAMS_MESSAGE_CONSUMERS` | `DBA_STREAMS_MESSAGE_CONSUMERS` |
`ALL_STREAMS_MESSAGE_RULES` | `DBA_STREAMS_MESSAGE_RULES` |
`ALL_STREAMS_NEWLY_SUPPORTED` | `DBA_STREAMS_NEWLY_SUPPORTED` |
`ALL_STREAMS_RULES` | `DBA_STREAMS_RULES` |
`ALL_STREAMS_TRANSFORM_FUNCTION` | `DBA_STREAMS_TRANSFORM_FUNCTION` |
`ALL_STREAMS_UNSUPPORTED` | `DBA_STREAMS_UNSUPPORTED` |
`ALL_TAB_STATISTICS` | `DBA_TAB_STATISTICS` | `USER_TAB_STATISTICS`
| `DBA_TABLESPACE_GROUPS` |
| `DBA_THRESHOLDS` |
| `DBA_TUNE_MVIEW` | `USER_TUNE_MVIEW`
`ALL_WARNING_SETTINGS` | `DBA_WARNING_SETTINGS` | `USER_WARNING_SETTINGS`

See Also: Part II, "Static Data Dictionary Views" for more information about these static data dictionary views

The following dynamic performance views are new to release 10.1:

GV$ Views | V$ Views
--- | ---
`GV$ACTIVE_SERVICES` | `V$ACTIVE_SERVICES`
`GV$ACTIVE_SESSION_HISTORY` | `V$ACTIVE_SESSION_HISTORY`
`GV$ALERT_TYPES` | `V$ALERT_TYPES`
`GV$ASM_ALIAS` | `V$ASM_ALIAS`
`GV$ASM_CLIENT` | `V$ASM_CLIENT`
`GV$ASM_DISK` | `V$ASM_DISK`
`GV$ASM_DISKGROUP` | `V$ASM_DISKGROUP`
`GV$ASM_FILE` | `V$ASM_FILE`
`GV$ASM_OPERATION` | `V$ASM_OPERATION`
`GV$ASM_TEMPLATE` | `V$ASM_TEMPLATE`
| `V$BACKUP_FILES`
| `V$BLOCK_CHANGE_TRACKING`
`GV$BUFFERED_PUBLISHERS` | `V$BUFFERED_PUBLISHERS`
`GV$BUFFERED_QUEUES` | `V$BUFFERED_QUEUES`
`GV$BUFFERED_SUBSCRIBERS` | `V$BUFFERED_SUBSCRIBERS`
`GV$CLIENT_STATS` | `V$CLIENT_STATS`
`GV$CURRENT_BLOCK_SERVER` | `V$CURRENT_BLOCK_SERVER`
`GV$DATAGUARD_CONFIG` | `V$DATAGUARD_CONFIG`
`GV$DISPATCHER_CONFIG` | `V$DISPATCHER_CONFIG`
`GV$EVENT_HISTOGRAM` | `V$EVENT_HISTOGRAM`
`GV$EVENTMETRIC` | `V$EVENTMETRIC`
`GV$FILE_HISTOGRAM` | `V$FILE_HISTOGRAM`
`GV$FILEMETRIC` | `V$FILEMETRIC`
`GV$FILEMETRIC_HISTORY` | `V$FILEMETRIC_HISTORY`
`GV$FLASHBACK_DATABASE_LOG` | `V$FLASHBACK_DATABASE_LOG`
`GV$FLASHBACK_DATABASE_STAT` | `V$FLASHBACK_DATABASE_STAT`
`GV$JAVA_LIBRARY_CACHE_MEMORY` | `V$JAVA_LIBRARY_CACHE_MEMORY`
`GV$JAVA_POOL_ADVICE` | `V$JAVA_POOL_ADVICE`
`GV$METRICNAME` | `V$METRICNAME`
`GV$OSSTAT` | `V$OSSTAT`
`GV$PROPAGATION_RECEIVER` | `V$PROPAGATION_RECEIVER`
`GV$PROPAGATION_SENDER` | `V$PROPAGATION_SENDER`
| `V$RECOVERY_FILE_DEST`
`GV$RMAN_OUTPUT` | `V$RMAN_OUTPUT`
| `V$RMAN_STATUS`
`GV$RULE` | `V$RULE`
`GV$RULE_SET` | `V$RULE_SET`
`GV$RULE_SET_AGGREGATE_STATS` | `V$RULE_SET_AGGREGATE_STATS`
`GV$SERV_MOD_ACT_STATS` | `V$SERV_MOD_ACT_STATS`
`GV$SERVICE_EVENT` | `V$SERVICE_EVENT`
`GV$SERVICE_STATS` | `V$SERVICE_STATS`
`GV$SERVICE_WAIT_CLASS` | `V$SERVICE_WAIT_CLASS`
`GV$SERVICEMETRIC` | `V$SERVICEMETRIC`
`GV$SERVICEMETRIC_HISTORY` | `V$SERVICEMETRIC_HISTORY`
`GV$SERVICES` | `V$SERVICES`
`GV$SES_OPTIMIZER_ENV` | `V$SES_OPTIMIZER_ENV`
`GV$SESS_TIME_MODEL` | `V$SESS_TIME_MODEL`
`GV$SESSION_WAIT_CLASS` | `V$SESSION_WAIT_CLASS`
`GV$SESSION_WAIT_HISTORY` | `V$SESSION_WAIT_HISTORY`
`GV$SESSMETRIC` | `V$SESSMETRIC`
`GV$SGAINFO` | `V$SGAINFO`
`GV$SQL_BIND_CAPTURE` | `V$SQL_BIND_CAPTURE`
`GV$SQL_OPTIMIZER_ENV` | `V$SQL_OPTIMIZER_ENV`
`GV$SYS_OPTIMIZER_ENV` | `V$SYS_OPTIMIZER_ENV`
`GV$SYS_TIME_MODEL` | `V$SYS_TIME_MODEL`
`GV$SYSAUX_OCCUPANTS` | `V$SYSAUX_OCCUPANTS`
`GV$SYSMETRIC` | `V$SYSMETRIC`
`GV$SYSMETRIC_HISTORY` | `V$SYSMETRIC_HISTORY`
`GV$SYSMETRIC_SUMMARY` | `V$SYSMETRIC_SUMMARY`
`GV$SYSTEM_WAIT_CLASS` | `V$SYSTEM_WAIT_CLASS`
`GV$TEMP_HISTOGRAM` | `V$TEMP_HISTOGRAM`
`GV$THRESHOLD_TYPES` | `V$THRESHOLD_TYPES`
| `V$TRANSPORTABLE_PLATFORM`
`GV$WAITCLASSMETRIC` | `V$WAITCLASSMETRIC`
`GV$WAITCLASSMETRIC_HISTORY` | `V$WAITCLASSMETRIC_HISTORY`

See Also: Part III, "Dynamic Performance Views" for more information about these dynamic performance views

The following static data dictionary views have new columns in release 10.1:

Static Data Dictionary View | New Columns
--- | ---
`ALL_ALL_TABLES` | `DROPPED`
`ALL_APPLY` | `PRECOMMIT_HANDLER` `MAX_APPLIED_MESSAGE_NUMBER` `NEGATIVE_RULE_SET_NAME` `NEGATIVE_RULE_SET_OWNER` `STATUS_CHANGE_TIME` `ERROR_NUMBER` `ERROR_MESSAGE`
`ALL_APPLY_DML_HANDLERS` | `APPLY_NAME`
`ALL_APPLY_PROGRESS` | `SOURCE_DATABASE`
`ALL_AUDIT_POLICIES` | `SEL` `INS` `UPD` `DEL` `AUDIT_TRAIL` `POLICY_COLUMN_OPTIONS`
`ALL_CAPTURE` | `CAPTURE_USER` `CAPTURED_SCN` `APPLIED_SCN` `USE_DATABASE_LINK` `FIRST_SCN` `SOURCE_DATABASE` `SOURCE_DBID` `SOURCE_RESETLOGS_SCN` `SOURCE_RESETLOGS_TIME` `LOGMINER_ID` `NEGATIVE_RULE_SET_NAME` `NEGATIVE_RULE_SET_OWNER` `MAX_CHECKPOINT_SCN` `REQUIRED_CHECKPOINT_SCN` `LOGFILE_ASSIGNMENT` `STATUS_CHANGE_TIME` `ERROR_NUMBER` `ERROR_MESSAGE` `VERSION` `CAPTURE_TYPE`
`ALL_DEF_AUDIT_OPTS` | `FBK`
`ALL_DIM_ATTRIBUTES` | `ATTRIBUTE_NAME`
`ALL_ERRORS` | `ATTRIBUTE` `MESSAGE_NUMBER`
`ALL_EXTERNAL_TABLES` | `PROPERTY`
`ALL_INDEXES` | `IOT_REDUNDANT_PKEY_ELIM` `DROPPED`
`ALL_INDEXTYPES` | `ARRAY_DML`
`ALL_LOBS` | `TABLESPACE_NAME` `FORMAT` `PARTITIONED`
`ALL_LOG_GROUP_COLUMNS` | `LOGGING_PROPERTY`
`ALL_LOG_GROUPS` | `LOG_GROUP_TYPE` `GENERATED`
`ALL_MVIEWS` | `UNKNOWN_TRUSTED_FD` `STALE_SINCE`
`ALL_OBJECT_TABLES` | `DROPPED`
`ALL_OUTLINES` | `COMPATIBLE` `ENABLED` `FORMAT`
`ALL_PART_COL_STATISTICS` | `HISTOGRAM`
`ALL_POLICIES` | `IDX` `POLICY_TYPE` `LONG_PREDICATE`
`ALL_PROPAGATION` | `NEGATIVE_RULE_SET_OWNER` `NEGATIVE_RULE_SET_NAME`
`ALL_SUBPART_COL_STATISTICS` | `HISTOGRAM`
`ALL_SUBSCRIBED_COLUMNS` | `SUBSCRIPTION_NAME`
`ALL_SUBSCRIBED_TABLES` | `SUBSCRIPTION_NAME`
`ALL_SUBSCRIPTIONS` | `SUBSCRIPTION_NAME`
`ALL_TAB_COL_STATISTICS` | `HISTOGRAM`
`ALL_TAB_COLS` | `HISTOGRAM` `QUALIFIED_COL_NAME`
`ALL_TAB_COLUMNS` | `HISTOGRAM`
`ALL_TAB_MODIFICATIONS` | `DROP_SEGMENTS`
`ALL_TABLES` | `DROPPED`
`DBA_ALL_TABLES` | `DROPPED`
`DBA_APPLY` | `PRECOMMIT_HANDLER` `MAX_APPLIED_MESSAGE_NUMBER` `NEGATIVE_RULE_SET_NAME` `NEGATIVE_RULE_SET_OWNER` `STATUS_CHANGE_TIME` `ERROR_NUMBER` `ERROR_MESSAGE`
`DBA_APPLY_DML_HANDLERS` | `APPLY_NAME`
`DBA_APPLY_PROGRESS` | `SOURCE_DATABASE`
`DBA_AUDIT_EXISTS` | `EXTENDED_TIMESTAMP` `PROXY_SESSIONID` `GLOBAL_UID` `INSTANCE_NUMBER` `OS_PROCESS` `TRANSACTIONID` `SCN` `SQL_BIND` `SQL_TEXT`
`DBA_AUDIT_OBJECT` | `EXTENDED_TIMESTAMP` `PROXY_SESSIONID` `GLOBAL_UID` `INSTANCE_NUMBER` `OS_PROCESS` `TRANSACTIONID` `SCN` `SQL_BIND` `SQL_TEXT`
`DBA_AUDIT_POLICIES` | `SEL` `INS` `UPD` `DEL` `AUDIT_TRAIL` `POLICY_COLUMN_OPTIONS`
`DBA_AUDIT_SESSION` | `EXTENDED_TIMESTAMP` `PROXY_SESSIONID` `GLOBAL_UID` `INSTANCE_NUMBER` `OS_PROCESS`
`DBA_AUDIT_STATEMENT` | `EXTENDED_TIMESTAMP` `PROXY_SESSIONID` `GLOBAL_UID` `INSTANCE_NUMBER` `OS_PROCESS` `TRANSACTIONID` `SCN` `SQL_BIND` `SQL_TEXT`
`DBA_AUDIT_TRAIL` | `EXTENDED_TIMESTAMP` `PROXY_SESSIONID` `GLOBAL_UID` `INSTANCE_NUMBER` `OS_PROCESS` `TRANSACTIONID` `SCN` `SQL_BIND` `SQL_TEXT`
`DBA_AW_PS` | `MAXPAGES`
`DBA_CAPTURE` | `CAPTURE_USER` `USE_DATABASE_LINK` `FIRST_SCN` `SOURCE_DATABASE` `SOURCE_DBID` `SOURCE_RESETLOGS_SCN` `SOURCE_RESETLOGS_TIME` `LOGMINER_ID` `NEGATIVE_RULE_SET_NAME` `NEGATIVE_RULE_SET_OWNER` `MAX_CHECKPOINT_SCN` `REQUIRED_CHECKPOINT_SCN` `LOGFILE_ASSIGNMENT` `STATUS_CHANGE_TIME` `ERROR_NUMBER` `ERROR_MESSAGE` `VERSION` `CAPTURE_TYPE`
`DBA_DIM_ATTRIBUTES` | `ATTRIBUTE_NAME`
`DBA_ERRORS` | `ATTRIBUTE` `MESSAGE_NUMBER`
`DBA_EXTERNAL_TABLES` | `PROPERTY`
`DBA_FGA_AUDIT_TRAIL` | `STATEMENT_TYPE` `EXTENDED_TIMESTAMP` `PROXY_SESSIONID` `GLOBAL_UID` `INSTANCE_NUMBER` `OS_PROCESS` `TRANSACTIONID` `STATEMENTID` `ENTRYID`
`DBA_INDEXES` | `IOT_REDUNDANT_PKEY_ELIM` `DROPPED`
`DBA_INDEXTYPES` | `ARRAY_DML`
`DBA_LOBS` | `TABLESPACE_NAME` `FORMAT` `PARTITIONED`
`DBA_LOG_GROUP_COLUMNS` | `LOGGING_PROPERTY`
`DBA_LOG_GROUPS` | `LOG_GROUP_TYPE` `GENERATED`
`DBA_LOGSTDBY_LOG` | `APPLIED`
`DBA_LOGSTDBY_PROGRESS` | `APPLIED_THREAD#` `APPLIED_SEQUENCE#` `READ_THREAD#` `READ_SEQUENCE#` `NEWEST_THREAD#` `NEWEST_SEQUENCE#`
`DBA_LOGSTDBY_SKIP` | `USE_LIKE` `ESC`
`DBA_LOGSTDBY_UNSUPPORTED` | `ATTRIBUTES`
`DBA_MVIEWS` | `UNKNOWN_TRUSTED_FD` `STALE_SINCE`
`DBA_OBJ_AUDIT_OPTS` | `FBK`
`DBA_OBJECT_TABLES` | `DROPPED`
`DBA_OUTLINES` | `COMPATIBLE` `ENABLED` `FORMAT`
`DBA_PART_COL_STATISTICS` | `HISTOGRAM`
`DBA_POLICIES` | `IDX` `POLICY_TYPE` `LONG_PREDICATE`
`DBA_PROPAGATION` | `NEGATIVE_RULE_SET_OWNER` `NEGATIVE_RULE_SET_NAME`
`DBA_PROXIES` | `AUTHENTICATION`
`DBA_REGISTRY` | `NAMESPACE`
`DBA_REGISTRY_HIERARCHY` | `NAMESPACE`
`DBA_RSRC_PLAN_DIRECTIVES` | `MAX_IDLE_TIME` `MAX_IDLE_BLOCKER_TIME` `SWITCH_TIME_IN_CALL`
`DBA_SUBPART_COL_STATISTICS` | `HISTOGRAM`
`DBA_SUBSCRIBED_COLUMNS` | `SUBSCRIPTION_NAME`
`DBA_SUBSCRIBED_TABLES` | `SUBSCRIPTION_NAME`
`DBA_SUBSCRIPTIONS` | `SUBSCRIPTION_NAME`
`DBA_TAB_COL_STATISTICS` | `HISTOGRAM`
`DBA_TAB_COLS` | `HISTOGRAM` `QUALIFIED_COL_NAME`
`DBA_TAB_COLUMNS` | `HISTOGRAM`
`DBA_TAB_MODIFICATIONS` | `DROP_SEGMENTS`
`DBA_TABLES` | `DROPPED`
`DBA_TABLESPACES` | `RETENTION` `BIGFILE`
`USER_ALL_TABLES` | `DROPPED`
`USER_AUDIT_OBJECT` | `EXTENDED_TIMESTAMP` `PROXY_SESSIONID` `GLOBAL_UID` `INSTANCE_NUMBER` `OS_PROCESS` `TRANSACTIONID` `SCN` `SQL_BIND` `SQL_TEXT`
`USER_AUDIT_POLICIES` | `SEL` `INS` `UPD` `DEL` `AUDIT_TRAIL` `POLICY_COLUMN_OPTIONS`
`USER_AUDIT_SESSION` | `EXTENDED_TIMESTAMP` `PROXY_SESSIONID` `GLOBAL_UID` `INSTANCE_NUMBER` `OS_PROCESS`
`USER_AUDIT_STATEMENT` | `EXTENDED_TIMESTAMP` `PROXY_SESSIONID` `GLOBAL_UID` `INSTANCE_NUMBER` `OS_PROCESS` `TRANSACTIONID` `SCN` `SQL_BIND` `SQL_TEXT`
`USER_AUDIT_TRAIL` | `EXTENDED_TIMESTAMP` `PROXY_SESSIONID` `GLOBAL_UID` `INSTANCE_NUMBER` `OS_PROCESS` `TRANSACTIONID` `SCN` `SQL_BIND` `SQL_TEXT`
`USER_AW_PS` | `MAXPAGES`
`USER_DIM_ATTRIBUTES` | `ATTRIBUTE_NAME`
`USER_ERRORS` | `ATTRIBUTE` `MESSAGE_NUMBER`
`USER_EXTERNAL_TABLES` | `PROPERTY`
`USER_INDEXES` | `IOT_REDUNDANT_PKEY_ELIM` `DROPPED`
`USER_INDEXTYPES` | `ARRAY_DML`
`USER_LOBS` | `TABLESPACE_NAME` `FORMAT` `PARTITIONED`
`USER_LOG_GROUP_COLUMNS` | `LOGGING_PROPERTY`
`USER_LOG_GROUPS` | `LOG_GROUP_TYPE` `GENERATED`
`USER_MVIEWS` | `UNKNOWN_TRUSTED_FD` `STALE_SINCE`
`USER_OBJ_AUDIT_OPTS` | `FBK`
`USER_OBJECT_TABLES` | `DROPPED`
`USER_OUTLINES` | `COMPATIBLE` `ENABLED` `FORMAT`
`USER_PART_COL_STATISTICS` | `HISTOGRAM`
`USER_POLICIES` | `IDX` `POLICY_TYPE` `LONG_PREDICATE`
`USER_PROXIES` | `AUTHENTICATION`
`USER_PUBLISHED_COLUMNS` | `CHANGE_SET_NAME` `PUB_ID`
`USER_REGISTRY` | `NAMESPACE`
`USER_SUBPART_COL_STATISTICS` | `HISTOGRAM`
`USER_SUBSCRIBED_COLUMNS` | `SUBSCRIPTION_NAME`
`USER_SUBSCRIBED_TABLES` | `SUBSCRIPTION_NAME`
`USER_SUBSCRIPTIONS` | `SUBSCRIPTION_NAME`
`USER_TAB_COL_STATISTICS` | `HISTOGRAM`
`USER_TAB_COLS` | `HISTOGRAM` `QUALIFIED_COL_NAME`
`USER_TAB_COLUMNS` | `HISTOGRAM`
`USER_TAB_MODIFICATIONS` | `DROP_SEGMENTS`
`USER_TABLES` | `DROPPED`
`USER_TABLESPACES` | `RETENTION` `BIGFILE`

See Also: Part II, "Static Data Dictionary Views" for more information about the new columns in these static data dictionary views

The following dynamic performance views have new columns in release 10.1:

Dynamic Performance View | New Columns
--- | ---
`GV$ARCHIVE_DEST` and `V$ARCHIVE_DEST` | `VALID_NOW` `VALID_TYPE` `VALID_ROLE` `DB_UNIQUE_NAME` `VERIFY` `EXPEDITE`
`GV$ARCHIVE_DEST_STATUS` and `V$ARCHIVE_DEST_STATUS` | `DB_UNIQUE_NAME`
`GV$ARCHIVED_LOG` and `V$ARCHIVED_LOG` | `RESETLOGS_ID` `IS_RECOVERY_DEST_FILE` `FAL`
`GV$AW_CALC` and `V$AW_CALC` | `SESSION_ID` `CURR_DML_COMMAND` `PREV_DML_COMMAND` `AGGR_FUNC_LOGICAL_NA` `AGGR_FUNC_PRECOMPUTE` `AGGR_FUNC_CALCS`
`GV$AW_SESSION_INFO` and `V$AW_SESSION_INFO` | `SESSION_ID`
`GV$BACKUP_ASYNC_IO` and `V$BACKUP_ASYNC_IO` | `RMAN_STATUS_RECID` `RMAN_STATUS_STAMP`
`GV$BACKUP_DATAFILE` and `V$BACKUP_DATAFILE` | `USED_CHANGE_TRACKING` `BLOCKS_READ`
`GV$BACKUP_PIECE` and `V$BACKUP_PIECE` | `BYTES` `IS_RECOVERY_DEST_FILE` `RMAN_STATUS_RECID` `RMAN_STATUS_STAMP` `COMPRESSED`
`GV$BACKUP_SYNC_IO` and `V$BACKUP_SYNC_IO` | `RMAN_STATUS_RECID` `RMAN_STATUS_STAMP`
`GV$BGPROCESS` and `V$BGPROCESS` | `PSERIAL#`
`GV$CLASS_CACHE_TRANSFER` and `V$CLASS_CACHE_TRANSFER` | `CR_TRANSFER` `CURRENT_TRANSFER`
`GV$CONTROLFILE` and `V$CONTROLFILE` | `IS_RECOVERY_DEST_FILE`
`GV$DATABASE` and `V$DATABASE` | `SWITCHOVER#` `PLATFORM_ID` `PLATFORM_NAME` `RECOVERY_TARGET_INCARNATION#` `LAST_OPEN_INCARNATION#` `CURRENT_SCN` `FLASHBACK_ON` `SUPPLEMENTAL_LOG_DATA_FK` `SUPPLEMENTAL_LOG_DATA_ALL` `DB_UNIQUE_NAME` `STANDBY_BECAME_PRIMARY_SCN`
`GV$DATABASE_INCARNATION` and `V$DATABASE_INCARNATION` | `INCARNATION#` `STATUS` `RESETLOGS_ID` `PRIOR_INCARNATION#`
`GV$DATAFILE_COPY` and `V$DATAFILE_COPY` | `IS_RECOVERY_DEST_FILE` `RMAN_STATUS_RECID` `RMAN_STATUS_STAMP`
`GV$DB_CACHE_ADVICE` and `V$DB_CACHE_ADVICE` | `ESTD_PHYSICAL_READ_TIME` `ESTD_PCT_OF_DB_TIME_FOR_READS`
`GV$EVENT_NAME` and `V$EVENT_NAME` | `EVENT_ID` `WAIT_CLASS_ID` `WAIT_CLASS#` `WAIT_CLASS`
`GV$FAST_START_SERVERS` and `V$FAST_START_SERVERS` | `XID`
`GV$FAST_START_TRANSACTIONS` and `V$FAST_START_TRANSACTIONS` | `XID` `PXID` `RCVSERVERS`
`GV$INSTANCE_RECOVERY` and `V$INSTANCE_RECOVERY` | `OPTIMAL_LOGFILE_SIZE` `ESTD_CLUSTER_AVAILABLE_TIME` `WRITES_MTTR` `WRITES_LOGFILE_SIZE` `WRITES_LOG_CHECKPOINT_SETTINGS` `WRITES_OTHER_SETTINGS` `WRITES_AUTOTUNE` `WRITES_FULL_THREAD_CKPT`
`GV$LATCH` and `V$LATCH` | `HASH`
`GV$LATCH_CHILDREN` and `V$LATCH_CHILDREN` | `HASH`
`GV$LATCH_PARENT` and `V$LATCH_PARENT` | `HASH`
`GV$LATCHNAME` and `V$LATCHNAME` | `HASH`
`GV$LOADISTAT` and `V$LOADISTAT` | `MESSAGE_NUM`
`GV$LOG_HISTORY` and `V$LOG_HISTORY` | `RESETLOGS_CHANGE#` `RESETLOGS_TIME`
`GV$LOGFILE` and `V$LOGFILE` | `IS_RECOVERY_DEST_FILE`
`GV$LOGMNR_CONTENTS` and `V$LOGMNR_CONTENTS` | `TABLE_NAME` `DATA_OBJV#` `SAFE_RESUME_SCN` `XID` `PXID` `AUDIT_SESSIONID`
`GV$LOGMNR_DICTIONARY` and `V$LOGMNR_DICTIONARY` | `DB_CREATED` `DB_VERSION_TIME` `DB_CHARACTER_SET` `DB_VERSION` `DB_STATUS` `DB_TXN_SCN`
`GV$LOGMNR_LOGS` and `V$LOGMNR_LOGS` | `TYPE` `BLOCKSIZE` `FILESIZE`
`GV$LOGMNR_PARAMETERS` and `V$LOGMNR_PARAMETERS` | `REQUIRED_START_DATE` `REQUIRED_START_SCN` `OPTIONS`
`GV$MANAGED_STANDBY` and `V$MANAGED_STANDBY` | `RESETLOG_ID`
`GV$OFFLINE_RANGE` and `V$OFFLINE_RANGE` | `RESETLOGS_CHANGE#` `RESETLOGS_TIME`
`GV$OPEN_CURSOR` and `V$OPEN_CURSOR` | `SQL_ID`
`GV$PARAMETER` and `V$PARAMETER` | `DISPLAY_VALUE` `ISINSTANCE_MODIFIABLE` `ISDEPRECATED` `HASH`
`GV$PARAMETER2` and `V$PARAMETER2` | `DISPLAY_VALUE` `ISINSTANCE_MODIFIABLE` `ISDEPRECATED`
`GV$PROXY_ARCHIVEDLOG` and `V$PROXY_ARCHIVEDLOG` | `TAG` `RMAN_STATUS_RECID` `RMAN_STATUS_STAMP`
`GV$PROXY_DATAFILE` and `V$PROXY_DATAFILE` | `RMAN_STATUS_RECID` `RMAN_STATUS_STAMP`
`GV$RSRC_PLAN` and `V$RSRC_PLAN` | `IS_TOP_PLAN`
`GV$SESSION` and `V$SESSION` | `SQL_ID` `SQL_CHILD_NUMBER` `PREV_SQL_ID` `PREV_CHILD_NUMBER` `BLOCKING_SESSION_STATUS` `BLOCKING_SESSION` `SEQ#` `EVENT#` `EVENT` `P1TEXT` `P1` `P1RAW` `P2TEXT` `P2` `P2RAW` `P3TEXT` `P3` `P3RAW` `WAIT_CLASS_ID` `WAIT_CLASS#` `WAIT_CLASS` `WAIT_TIME` `SECONDS_IN_WAIT` `STATE` `SERVICE_NAME`
`GV$SESSION_EVENT` and `V$SESSION_EVENT` | `EVENT_ID`
`GV$SESSION_LONGOPS` and `V$SESSION_LONGOPS` | `SQL_ID`
`GV$SESSION_WAIT` and `V$SESSION_WAIT` | `WAIT_CLASS_ID` `WAIT_CLASS#` `WAIT_CLASS`
`GV$SGA_DYNAMIC_COMPONENTS` and `V$SGA_DYNAMIC_COMPONENTS` | `USER_SPECIFIED_SIZE`
`GV$SHARED_POOL_ADVICE` and `V$SHARED_POOL_ADVICE` | `ESTD_LC_LOAD_TIME` `ESTD_LC_LOAD_TIME_FACTOR`
`GV$SPPARAMETER` and `V$SPPARAMETER` | `DISPLAY_VALUE`
`GV$SQL` and `V$SQL` | `SQL_FULLTEXT` `SQL_ID` `END_OF_FETCH_COUNT` `DIRECT_WRITES` `APPLICATION_WAIT_TIME` `CONCURRENCY_WAIT_TIME` `CLUSTER_WAIT_TIME` `USER_IO_WAIT_TIME` `PLSQL_EXEC_TIME` `JAVA_EXEC_TIME` `OPTIMIZER_ENV` `OPTIMIZER_ENV_HASH_VALUE` `OLD_HASH_VALUE` `SQL_PROFILE` `PROGRAM_ID` `PROGRAM_LINE#`
`GV$SQL_PLAN` and `V$SQL_PLAN` | `SQL_ID` `PLAN_HASH_VALUE` `OBJECT_ALIAS` `OBJECT_TYPE` `PROJECTION` `TIME` `QBLOCK_NAME` `REMARKS`
`GV$SQL_PLAN_STATISTICS` and `V$SQL_PLAN_STATISTICS` | `SQL_ID` `PLAN_HASH_VALUE`
`GV$SQL_PLAN_STATISTICS_ALL` and `V$SQL_PLAN_STATISTICS_ALL` | `SQL_ID` `PLAN_HASH_VALUE` `OBJECT_ALIAS` `OBJECT_TYPE` `PROJECTION` `TIME` `QBLOCK_NAME` `REMARKS`
`GV$SQL_REDIRECTION` and `V$SQL_REDIRECTION` | `SQL_ID`
`GV$SQL_SHARED_CURSOR` and `V$SQL_SHARED_CURSOR` | `SQL_ID` `CHILD_ADDRESS` `CHILD_NUMBER` `ANYDATA_TRANSFORMATION` `INCOMPLETE_CURSOR` `TOP_LEVEL_RPI_CURSOR` `DIFFERENT_LONG_LENGTH` `LOGICAL_STANDBY_APPLY` `DIFF_CALL_DURN` `BIND_UACS_DIFF` `PLSQL_CMP_SWITCHS_DIFF`
`GV$SQL_SHARED_MEMORY` and `V$SQL_SHARED_MEMORY` | `SQL_FULLTEXT` `SQL_ID`
`GV$SQL_WORKAREA` and `V$SQL_WORKAREA` | `SQL_ID`
`GV$SQL_WORKAREA_ACTIVE` and `V$SQL_WORKAREA_ACTIVE` | `SQL_HASH_VALUE` `SQL_ID`
`GV$SQLAREA` and `V$SQLAREA` | `SQL_ID` `END_OF_FETCH_COUNT` `DIRECT_WRITES` `APPLICATION_WAIT_TIME` `CONCURRENCY_WAIT_TIME` `CLUSTER_WAIT_TIME` `USER_IO_WAIT_TIME` `PLSQL_EXEC_TIME` `JAVA_EXEC_TIME` `OLD_HASH_VALUE` `PROGRAM_ID`
`GV$SQLTEXT` and `V$SQLTEXT` | `SQL_ID`
`GV$SQLTEXT_WITH_NEWLINES` and `V$SQLTEXT_WITH_NEWLINES` | `SQL_ID`
`GV$STANDBY_LOG` and `V$STANDBY_LOG` | `DBID`
`GV$STATNAME` and `V$STATNAME` | `STAT_ID`
`GV$STREAMS_APPLY_COORDINATOR` and `V$STREAMS_APPLY_COORDINATOR` | `TOTAL_IGNORED` `TOTAL_ROLLBACKS`
`GV$STREAMS_APPLY_READER` and `V$STREAMS_APPLY_READER` | `LAST_BROWSE_NUM` `OLDEST_SCN_NUM` `LAST_BROWSE_SEQ` `LAST_DEQ_SEQ`
`GV$STREAMS_APPLY_SERVER` and `V$STREAMS_APPLY_SERVER` | `TOTAL_ROLLBACKS`
`GV$STREAMS_CAPTURE` and `V$STREAMS_CAPTURE` | `LOGMINER_ID` `TOTAL_PREFILTER_DISCARDED` `TOTAL_PREFILTER_KEPT` `TOTAL_PREFILTER_EVALUATIONS` `TOTAL_MESSAGES_CREATED` `TOTAL_FULL_EVALUATIONS` `AVAILABLE_MESSAGE_NUMBER` `AVAILABLE_MESSAGE_CREATE_TIME` `ELAPSED_REDO_WAIT_TIME` `ELAPSED_PAUSE_TIME`
`GV$SYSSTAT` and `V$SYSSTAT` | `STAT_ID`
`GV$SYSTEM_EVENT` and `V$SYSTEM_EVENT` | `EVENT_ID`
`GV$SYSTEM_PARAMETER` and `V$SYSTEM_PARAMETER` | `DISPLAY_VALUE` `ISINSTANCE_MODIFIABLE` `ISDEPRECATED` `HASH`
`GV$SYSTEM_PARAMETER2` and `V$SYSTEM_PARAMETER2` | `DISPLAY_VALUE` `ISINSTANCE_MODIFIABLE` `ISDEPRECATED`
`GV$TABLESPACE` and `V$TABLESPACE` | `BIGFILE` `FLASHBACK_ON`
`GV$TEMPORARY_LOBS` and `V$TEMPORARY_LOBS` | `ABSTRACT_LOBS`
`GV$TEMPSEG_USAGE` and `V$TEMPSEG_USAGE` | `SQL_ID`
`GV$TRANSACTION` and `V$TRANSACTION` | `START_DATE` `DSCN_BASE` `DSCN_WRAP` `START_SCN` `DEPENDENT_SCN` `XID` `PRV_XID` `PTX_XID`
`GV$UNDOSTAT` and `V$UNDOSTAT` | `MAXQUERYID` `ACTIVEBLKS` `UNEXPIREDBLKS` `EXPIREDBLKS` `TUNED_UNDORETENTION`
`GV$VPD_POLICY` and `V$VPD_POLICY` | `SQL_ID`

See Also: Part III, "Dynamic Performance Views" for more information about the new columns in these dynamic performance views